package com.study.model.jdao;

import java.util.List;

import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.CrudRepository;

import com.study.model.pojo.Menubar;

public interface MenubarJdao extends CrudRepository<Menubar, Integer>{
	/**
	 * 根据员工ID查询主菜单
	 * */
	@Query("SELECT DISTINCT m FROM Menubar m,Empwithright em WHERE m.rid=em.rid AND em.eid=?1")
		public List<Menubar> queryByeid(int eid);
}
